/*
 Navicat Premium Data Transfer

 Source Server         : ali-mysql
 Source Server Type    : MySQL
 Source Server Version : 80026
 Source Host           : 39.107.92.215:3306
 Source Schema         : mall-sys

 Target Server Type    : MySQL
 Target Server Version : 80026
 File Encoding         : 65001

 Date: 08/11/2021 15:30:17
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tb_order_detail
-- ----------------------------
DROP TABLE IF EXISTS `tb_order_detail`;
CREATE TABLE `tb_order_detail` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '订单详情id ',
  `order_id` bigint NOT NULL COMMENT '订单id',
  `sku_id` bigint NOT NULL COMMENT 'sku商品id',
  `num` int NOT NULL COMMENT '购买数量',
  `title` varchar(256) NOT NULL COMMENT '商品标题',
  `own_spec` varchar(1024) DEFAULT '' COMMENT '商品动态属性键值集',
  `price` bigint NOT NULL COMMENT '价格,单位：分',
  `image` varchar(128) DEFAULT '' COMMENT '商品图片',
  PRIMARY KEY (`id`),
  KEY `key_order_id` (`order_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=227 DEFAULT CHARSET=utf8mb3 COMMENT='订单详情表';

-- ----------------------------
-- Records of tb_order_detail
-- ----------------------------
BEGIN;
INSERT INTO `tb_order_detail` VALUES (194, 1452250719485825024, 26399498944, 1, '华为（HUAWEI） nova 3e 手机 幻夜黑 全网通(4G+128G)', '{\"4\":\"幻夜黑\",\"12\":\"4GB\",\"13\":\"64GB\"}', 219900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/8/13/1524297505544.jpg');
INSERT INTO `tb_order_detail` VALUES (195, 1452250719485825024, 5568865, 3, '360手机 F5 移动版 2GB+16GB 流光金 移动联通4G手机 双卡双待', '{\"4\":\"流光金\",\"12\":\"2GB\",\"13\":\"16GB\"}', 37900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/5/6/1524297412607.jpg');
INSERT INTO `tb_order_detail` VALUES (196, 1452250719485825024, 21690477583, 1, '小米 红米5Plus 手机 金色 全网通(4G+64G)', '{\"4\":\"金色\",\"12\":\"4GB\",\"13\":\"64GB\"}', 109900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/2/11/1524297549175.jpg');
INSERT INTO `tb_order_detail` VALUES (197, 1452250719485825024, 18167356217, 1, '华为（HUAWEI） Mate10 手机 亮黑色 全网通(6G+128G)', '{\"4\":\"亮黑色\",\"12\":\"6GB\",\"13\":\"128GB\"}', 419900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/6/8/1524297653849.jpg');
INSERT INTO `tb_order_detail` VALUES (198, 1452250719485825024, 22870158060, 1, '小米 红米5Plus 手机 黑色 全网通(4G+64G)', '{\"4\":\"黑色\",\"12\":\"4GB\",\"13\":\"64GB\"}', 109900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/2/8/1524297549719.jpg');
INSERT INTO `tb_order_detail` VALUES (199, 1452250719485825024, 10781492357, 9, '华为（HUAWEI） nova 智能手机 4G手机 玫瑰金 (4G+64G)高配', '{\"4\":\"玫瑰金\",\"12\":\"4GB\",\"13\":\"64GB\"}', 109900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/7/14/1524297466806.jpg');
INSERT INTO `tb_order_detail` VALUES (200, 1452250719485825024, 11565700466, 1, '华为（HUAWEI） nova 手机 玫瑰金 移动全网(4G+64G)', '{\"4\":\"玫瑰金\",\"12\":\"4GB\",\"13\":\"64GB\"}', 111900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/12/1/1524297482382.jpg');
INSERT INTO `tb_order_detail` VALUES (201, 1452250719485825024, 18180585426, 2, '华为（HUAWEI） Mate10 Pro 手机 宝石蓝色 全网通4G(6G+128G)', '{\"4\":\"宝石蓝色\",\"12\":\"6GB\",\"13\":\"128GB\"}', 499900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/7/12/1524297574727.jpg');
INSERT INTO `tb_order_detail` VALUES (202, 1452250719485825024, 25435828092, 1, '小米 红米5Plus 手机 玫瑰金 全网通(4G+64G)', '{\"4\":\"玫瑰金\",\"12\":\"4GB\",\"13\":\"64GB\"}', 109900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/12/15/1524297550186.jpg');
INSERT INTO `tb_order_detail` VALUES (203, 1452250719485825024, 26399498946, 1, '华为（HUAWEI） nova 3e 手机 克莱因蓝 全网通(4G+128G)', '{\"4\":\"克莱因蓝\",\"12\":\"4GB\",\"13\":\"64GB\"}', 219900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/1/3/1524297506461.jpg');
INSERT INTO `tb_order_detail` VALUES (204, 1452250719485825024, 21690477587, 1, '小米 红米5Plus 手机 浅蓝色 全网通(4G+64G)', '{\"4\":\"浅蓝色\",\"12\":\"4GB\",\"13\":\"64GB\"}', 109900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/3/0/1524297550545.jpg');
INSERT INTO `tb_order_detail` VALUES (205, 1452252069158326272, 26399498944, 1, '华为（HUAWEI） nova 3e 手机 幻夜黑 全网通(4G+128G)', '{\"4\":\"幻夜黑\",\"12\":\"4GB\",\"13\":\"64GB\"}', 219900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/8/13/1524297505544.jpg');
INSERT INTO `tb_order_detail` VALUES (206, 1452252069158326272, 5568865, 3, '360手机 F5 移动版 2GB+16GB 流光金 移动联通4G手机 双卡双待', '{\"4\":\"流光金\",\"12\":\"2GB\",\"13\":\"16GB\"}', 37900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/5/6/1524297412607.jpg');
INSERT INTO `tb_order_detail` VALUES (207, 1452252069158326272, 21690477583, 2, '小米 红米5Plus 手机 金色 全网通(4G+64G)', '{\"4\":\"金色\",\"12\":\"4GB\",\"13\":\"64GB\"}', 109900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/2/11/1524297549175.jpg');
INSERT INTO `tb_order_detail` VALUES (208, 1452252069158326272, 18167356217, 1, '华为（HUAWEI） Mate10 手机 亮黑色 全网通(6G+128G)', '{\"4\":\"亮黑色\",\"12\":\"6GB\",\"13\":\"128GB\"}', 419900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/6/8/1524297653849.jpg');
INSERT INTO `tb_order_detail` VALUES (209, 1452252069158326272, 22870158060, 1, '小米 红米5Plus 手机 黑色 全网通(4G+64G)', '{\"4\":\"黑色\",\"12\":\"4GB\",\"13\":\"64GB\"}', 109900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/2/8/1524297549719.jpg');
INSERT INTO `tb_order_detail` VALUES (210, 1452252069158326272, 10781492357, 9, '华为（HUAWEI） nova 智能手机 4G手机 玫瑰金 (4G+64G)高配', '{\"4\":\"玫瑰金\",\"12\":\"4GB\",\"13\":\"64GB\"}', 109900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/7/14/1524297466806.jpg');
INSERT INTO `tb_order_detail` VALUES (211, 1452252069158326272, 11565700466, 1, '华为（HUAWEI） nova 手机 玫瑰金 移动全网(4G+64G)', '{\"4\":\"玫瑰金\",\"12\":\"4GB\",\"13\":\"64GB\"}', 111900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/12/1/1524297482382.jpg');
INSERT INTO `tb_order_detail` VALUES (212, 1452252069158326272, 18180585426, 2, '华为（HUAWEI） Mate10 Pro 手机 宝石蓝色 全网通4G(6G+128G)', '{\"4\":\"宝石蓝色\",\"12\":\"6GB\",\"13\":\"128GB\"}', 499900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/7/12/1524297574727.jpg');
INSERT INTO `tb_order_detail` VALUES (213, 1452252069158326272, 25435828092, 1, '小米 红米5Plus 手机 玫瑰金 全网通(4G+64G)', '{\"4\":\"玫瑰金\",\"12\":\"4GB\",\"13\":\"64GB\"}', 109900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/12/15/1524297550186.jpg');
INSERT INTO `tb_order_detail` VALUES (214, 1452252069158326272, 26399498946, 1, '华为（HUAWEI） nova 3e 手机 克莱因蓝 全网通(4G+128G)', '{\"4\":\"克莱因蓝\",\"12\":\"4GB\",\"13\":\"64GB\"}', 219900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/1/3/1524297506461.jpg');
INSERT INTO `tb_order_detail` VALUES (215, 1452252069158326272, 21690477587, 1, '小米 红米5Plus 手机 浅蓝色 全网通(4G+64G)', '{\"4\":\"浅蓝色\",\"12\":\"4GB\",\"13\":\"64GB\"}', 109900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/3/0/1524297550545.jpg');
INSERT INTO `tb_order_detail` VALUES (216, 1452253505933938688, 26399498944, 1, '华为（HUAWEI） nova 3e 手机 幻夜黑 全网通(4G+128G)', '{\"4\":\"幻夜黑\",\"12\":\"4GB\",\"13\":\"64GB\"}', 219900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/8/13/1524297505544.jpg');
INSERT INTO `tb_order_detail` VALUES (217, 1452253505933938688, 5568865, 3, '360手机 F5 移动版 2GB+16GB 流光金 移动联通4G手机 双卡双待', '{\"4\":\"流光金\",\"12\":\"2GB\",\"13\":\"16GB\"}', 37900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/5/6/1524297412607.jpg');
INSERT INTO `tb_order_detail` VALUES (218, 1452253505933938688, 21690477583, 2, '小米 红米5Plus 手机 金色 全网通(4G+64G)', '{\"4\":\"金色\",\"12\":\"4GB\",\"13\":\"64GB\"}', 109900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/2/11/1524297549175.jpg');
INSERT INTO `tb_order_detail` VALUES (219, 1452253505933938688, 18167356217, 1, '华为（HUAWEI） Mate10 手机 亮黑色 全网通(6G+128G)', '{\"4\":\"亮黑色\",\"12\":\"6GB\",\"13\":\"128GB\"}', 419900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/6/8/1524297653849.jpg');
INSERT INTO `tb_order_detail` VALUES (220, 1452253505933938688, 22870158060, 1, '小米 红米5Plus 手机 黑色 全网通(4G+64G)', '{\"4\":\"黑色\",\"12\":\"4GB\",\"13\":\"64GB\"}', 109900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/2/8/1524297549719.jpg');
INSERT INTO `tb_order_detail` VALUES (221, 1452253505933938688, 10781492357, 10, '华为（HUAWEI） nova 智能手机 4G手机 玫瑰金 (4G+64G)高配', '{\"4\":\"玫瑰金\",\"12\":\"4GB\",\"13\":\"64GB\"}', 109900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/7/14/1524297466806.jpg');
INSERT INTO `tb_order_detail` VALUES (222, 1452253505933938688, 11565700466, 1, '华为（HUAWEI） nova 手机 玫瑰金 移动全网(4G+64G)', '{\"4\":\"玫瑰金\",\"12\":\"4GB\",\"13\":\"64GB\"}', 111900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/12/1/1524297482382.jpg');
INSERT INTO `tb_order_detail` VALUES (223, 1452253505933938688, 18180585426, 2, '华为（HUAWEI） Mate10 Pro 手机 宝石蓝色 全网通4G(6G+128G)', '{\"4\":\"宝石蓝色\",\"12\":\"6GB\",\"13\":\"128GB\"}', 499900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/7/12/1524297574727.jpg');
INSERT INTO `tb_order_detail` VALUES (224, 1452253505933938688, 25435828092, 1, '小米 红米5Plus 手机 玫瑰金 全网通(4G+64G)', '{\"4\":\"玫瑰金\",\"12\":\"4GB\",\"13\":\"64GB\"}', 109900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/12/15/1524297550186.jpg');
INSERT INTO `tb_order_detail` VALUES (225, 1452253505933938688, 26399498946, 1, '华为（HUAWEI） nova 3e 手机 克莱因蓝 全网通(4G+128G)', '{\"4\":\"克莱因蓝\",\"12\":\"4GB\",\"13\":\"64GB\"}', 219900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/1/3/1524297506461.jpg');
INSERT INTO `tb_order_detail` VALUES (226, 1452253505933938688, 21690477587, 1, '小米 红米5Plus 手机 浅蓝色 全网通(4G+64G)', '{\"4\":\"浅蓝色\",\"12\":\"4GB\",\"13\":\"64GB\"}', 109900, 'https://jshop-item-img.oss-cn-beijing.aliyuncs.com/static/images/3/0/1524297550545.jpg');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
